﻿CREATE TABLE [dbo].[Award_Punish] (
    [Id]          INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [EId]         INT            CONSTRAINT [DF_Award_Punish_EId] DEFAULT ((0)) NOT NULL,
    [AContent]    NVARCHAR (MAX) CONSTRAINT [DF_Award_Punish_AContent] DEFAULT ('') NULL,
    [EntryPeople] NVARCHAR (50)  CONSTRAINT [DF_Award_Punish_EntryPeople] DEFAULT ('') NULL,
    [EntryTime]   DATETIME       CONSTRAINT [DF_Award_Punish_EntryTime] DEFAULT (getdate()) NULL,
    [EName]       NVARCHAR (50)  CONSTRAINT [DF_Award_Punish_EName] DEFAULT ('') NULL,
    [Cid]         INT            CONSTRAINT [DF_Award_Punish_Cid] DEFAULT ((0)) NULL,
    [Did]         INT            CONSTRAINT [DF_Award_Punish_Did] DEFAULT ((0)) NULL,
    [Temp]        INT            CONSTRAINT [DF_Award_Punish_Temp] DEFAULT ((0)) NULL,
    [Reason]      NVARCHAR (MAX) NULL,
    CONSTRAINT [PK_Award_Punish] PRIMARY KEY CLUSTERED ([Id] ASC)
);

